import pandas as pd
import numpy as np

# 导入数据
Images_by_GlobalID = pd.read_csv(r"F:\SCIENCE_AND_MATH\Machine Learning\MCM\2021C\2021MCM_ProblemC_ Images_by_GlobalID.CSV")
MCMProblemC_DataSet = pd.read_csv(r"F:\SCIENCE_AND_MATH\Machine Learning\MCM\2021C\2021MCMProblemC_DataSet.CSV")

data_merged = pd.merge(Images_by_GlobalID, MCMProblemC_DataSet, on="GlobalID")
# print(data_table)

data_merged.to_csv(r"F:\SCIENCE_AND_MATH\Machine Learning\MCM\2021C\data_merged.csv")